select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Green and Black Ruffled Organza Ruched Quinceanera Dresses

Black and Blue Organza Quinceanera Dresses with Ruffles

Two Toned Ruffled Organza Beaded Sweet Sixteen Dresses

Two Toned Ball Gown Organza Beaded Dress for Quinceaneras

Two Toned Sweetheart Tulle Quinceanera Dresses with Beading

Two Toned Layered Organza Appliques Sweet Sixteen Dresses

Multi Color One Shoulder Dress for Quinceaneras with Ruffles Beyonce dress

Multi Color Organza Sweet Sixteen Dresses with Ruffles

Multi Color Sweetheart Tulle Beaded Sweet Sixteen Dresses

Fuchsia Ball Gown Embroidery Sweet Sixteen Dresses Floor-length

Lace Hem Decorated Strapless Quinceanera Dresses Custom Made

Strapless Beaded Bodice Fuchsia Quinceanera Dress with Pick-ups

Two-toned Sweetheart Ruffles Dresses Quinceanera with Appliques

Ball Gown Beaded and Ruched Dresses for a Quinceanera in Style

Multi-colored Sweetheart Dresses for a Quince with Ruffled Layers

American Music Awards Recommended Ball Gown Beading Sweet 15 Dresses with Pick-ups

Paris Fashion Week Ruched and Beaded Sweetheart Dress for a Quinceanera with Ruffles

Hot Pink Pick-ups Sweet Sixteen Dresses with Beading and Ruches

Multi-colored Pick-ups and Ruffles Dresses for a Quince Hot Sale

Beading Sweetheart Apple Green Dresses for Sweet 16 with Ruffles

berlin film festival 2014 Two-toned Strapless Beading Quinceanera Dresses in Organza

Yellow One Shoulder Applique Quince Dresses with Ruffled Layers

Colorful Off the Shoulder Appliques Quinceanera Gown in Organza

Leopard Printed Beading Sweetheart Quinceanera Dress with Ruffle

Lovely Strapless Ruffles Dress for Quince with Floral Embellishment

Luxurious Strapless Two-toned Sweet Fifteen Dresses with Ruffles

Two-toned Ruffles Sweetheart Quinceanera Party Dress in Organza

Yellow Green Organza Ruffles Dresses Quinceanera with Appliques

Colorful Ruffles Vestidos De Quinceanera with Ruches and Beading

Purple and White Embroidery Dress for Quince in Taffeta and Tulle